3.9 KB · ⇊ 3 parts · ⤓ Micron 3.9 KB · ⤓ HTML 24.9 KB

top

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language. It was formally adopted in July 2008.cite-ref-sybase08-1-0[1] The standard consists of 9 parts which are described in detail in SQL. The next iteration is SQL:2011

• New features

• Documentation

• Claims of conformance

• See also

• References

• External links

Additions to the Foundation include

• enhanced MERGE and DIAGNOSTIC statements,

• the TRUNCATE TABLE statement,

• comma-separated WHEN clauses in a CASE expression,

• INSTEAD OF database triggers,

• partitioned JOIN tables,

• support for various XQuery regular expression/pattern-matching features, and

• enhancements to derived column names.cite-ref-sybase08-1-1[1]

The SQL standards documentation is not freely available but may be purchased from the ISO as ISO/IEC 9075(1-4,9-11,13,14):2008.

The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the Foundation and the Information and Definition Schemas.cite-ref-2[2]

Wikibooks has a book on the topic of:

Structured Query Language

• Structured Query Language

cite-note-sybase08-11. ↑ SQL:2008 now an approved ISO International Standard Archived 2011-06-28 at the Wayback Machine, a July 29th, 2008 blog post from a Sybase blog

cite-note-22. ↑ Oracle Compliance To Core SQL:2008 from Oracle Corporation

• Freely downloadable drafts of this standard